﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet" targetNamespace="http://tempuri.org/DataSet.xsd" xmlns:mstns="http://tempuri.org/DataSet.xsd" xmlns="http://tempuri.org/DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Web.config)" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ConnectionString.ConnectionString" Provider="System.Data.OracleClient" />
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="NguyenManhThangConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="NguyenManhThangConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.NguyenManhThangConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTopicTableAdapter" GeneratorDataComponentClassName="tblTopicTableAdapter" Name="tblTopic" UserDataComponentName="tblTopicTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="NguyenManhThangConnectionString (Web.config)" DbObjectName="NguyenManhThang.dbo.tblTopic" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblTopic] WHERE (([PK_iTopicID] = @Original_PK_iTopicID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PK_iTopicID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PK_iTopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblTopic] ([FK_sCategoryID], [FK_sFileID], [FK_iAccountID], [sUsername], [sTitle], [sLinkImage], [sContent], [sDescription], [sExtend], [iVisit], [iLike], [iStatus], [tDateTimeCreate], [tDateTimeModify]) VALUES (@FK_sCategoryID, @FK_sFileID, @FK_iAccountID, @sUsername, @sTitle, @sLinkImage, @sContent, @sDescription, @sExtend, @iVisit, @iLike, @iStatus, @tDateTimeCreate, @tDateTimeModify)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FK_sCategoryID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FK_sCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FK_sFileID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FK_sFileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FK_iAccountID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FK_iAccountID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sUsername" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sUsername" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sLinkImage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sLinkImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sContent" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sContent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sExtend" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sExtend" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iVisit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iVisit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iLike" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iLike" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@iStatus" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="iStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tDateTimeCreate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tDateTimeCreate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tDateTimeModify" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tDateTimeModify" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PK_iTopicID, FK_sCategoryID, FK_sFileID, FK_iAccountID, sUsername, sTitle, sLinkImage, sContent, sDescription, sExtend, iVisit, iLike, iStatus, tDateTimeCreate, tDateTimeModify FROM dbo.tblTopic</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblTopic] SET [FK_sCategoryID] = @FK_sCategoryID, [FK_sFileID] = @FK_sFileID, [FK_iAccountID] = @FK_iAccountID, [sUsername] = @sUsername, [sTitle] = @sTitle, [sLinkImage] = @sLinkImage, [sContent] = @sContent, [sDescription] = @sDescription, [sExtend] = @sExtend, [iVisit] = @iVisit, [iLike] = @iLike, [iStatus] = @iStatus, [tDateTimeCreate] = @tDateTimeCreate, [tDateTimeModify] = @tDateTimeModify WHERE (([PK_iTopicID] = @Original_PK_iTopicID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FK_sCategoryID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FK_sCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FK_sFileID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FK_sFileID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FK_iAccountID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FK_iAccountID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sUsername" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sUsername" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sLinkImage" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sLinkImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sContent" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sContent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sExtend" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sExtend" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iVisit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iVisit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iLike" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iLike" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@iStatus" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="iStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tDateTimeCreate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tDateTimeCreate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tDateTimeModify" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tDateTimeModify" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PK_iTopicID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PK_iTopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PK_iTopicID" DataSetColumn="PK_iTopicID" />
              <Mapping SourceColumn="FK_sCategoryID" DataSetColumn="FK_sCategoryID" />
              <Mapping SourceColumn="FK_sFileID" DataSetColumn="FK_sFileID" />
              <Mapping SourceColumn="FK_iAccountID" DataSetColumn="FK_iAccountID" />
              <Mapping SourceColumn="sUsername" DataSetColumn="sUsername" />
              <Mapping SourceColumn="sTitle" DataSetColumn="sTitle" />
              <Mapping SourceColumn="sLinkImage" DataSetColumn="sLinkImage" />
              <Mapping SourceColumn="sContent" DataSetColumn="sContent" />
              <Mapping SourceColumn="sDescription" DataSetColumn="sDescription" />
              <Mapping SourceColumn="sExtend" DataSetColumn="sExtend" />
              <Mapping SourceColumn="iVisit" DataSetColumn="iVisit" />
              <Mapping SourceColumn="iLike" DataSetColumn="iLike" />
              <Mapping SourceColumn="iStatus" DataSetColumn="iStatus" />
              <Mapping SourceColumn="tDateTimeCreate" DataSetColumn="tDateTimeCreate" />
              <Mapping SourceColumn="tDateTimeModify" DataSetColumn="tDateTimeModify" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="DataSet" msprop:Generator_UserDSName="DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblTopic" msprop:Generator_TableClassName="tblTopicDataTable" msprop:Generator_TableVarName="tabletblTopic" msprop:Generator_TablePropName="tblTopic" msprop:Generator_RowDeletingName="tblTopicRowDeleting" msprop:Generator_UserTableName="tblTopic" msprop:Generator_RowChangingName="tblTopicRowChanging" msprop:Generator_RowEvHandlerName="tblTopicRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTopicRowDeleted" msprop:Generator_RowEvArgName="tblTopicRowChangeEvent" msprop:Generator_RowChangedName="tblTopicRowChanged" msprop:Generator_RowClassName="tblTopicRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PK_iTopicID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPK_iTopicID" msprop:Generator_ColumnPropNameInRow="PK_iTopicID" msprop:Generator_ColumnPropNameInTable="PK_iTopicIDColumn" msprop:Generator_UserColumnName="PK_iTopicID" type="xs:int" />
              <xs:element name="FK_sCategoryID" msprop:Generator_ColumnVarNameInTable="columnFK_sCategoryID" msprop:Generator_ColumnPropNameInRow="FK_sCategoryID" msprop:Generator_ColumnPropNameInTable="FK_sCategoryIDColumn" msprop:Generator_UserColumnName="FK_sCategoryID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FK_sFileID" msprop:Generator_ColumnVarNameInTable="columnFK_sFileID" msprop:Generator_ColumnPropNameInRow="FK_sFileID" msprop:Generator_ColumnPropNameInTable="FK_sFileIDColumn" msprop:Generator_UserColumnName="FK_sFileID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FK_iAccountID" msprop:Generator_ColumnVarNameInTable="columnFK_iAccountID" msprop:Generator_ColumnPropNameInRow="FK_iAccountID" msprop:Generator_ColumnPropNameInTable="FK_iAccountIDColumn" msprop:Generator_UserColumnName="FK_iAccountID" type="xs:int" />
              <xs:element name="sUsername" msprop:Generator_ColumnVarNameInTable="columnsUsername" msprop:Generator_ColumnPropNameInRow="sUsername" msprop:Generator_ColumnPropNameInTable="sUsernameColumn" msprop:Generator_UserColumnName="sUsername">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sTitle" msprop:Generator_ColumnVarNameInTable="columnsTitle" msprop:Generator_ColumnPropNameInRow="sTitle" msprop:Generator_ColumnPropNameInTable="sTitleColumn" msprop:Generator_UserColumnName="sTitle">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sLinkImage" msprop:Generator_ColumnVarNameInTable="columnsLinkImage" msprop:Generator_ColumnPropNameInRow="sLinkImage" msprop:Generator_ColumnPropNameInTable="sLinkImageColumn" msprop:Generator_UserColumnName="sLinkImage">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sContent" msprop:Generator_ColumnVarNameInTable="columnsContent" msprop:Generator_ColumnPropNameInRow="sContent" msprop:Generator_ColumnPropNameInTable="sContentColumn" msprop:Generator_UserColumnName="sContent">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sDescription" msprop:Generator_ColumnVarNameInTable="columnsDescription" msprop:Generator_ColumnPropNameInRow="sDescription" msprop:Generator_ColumnPropNameInTable="sDescriptionColumn" msprop:Generator_UserColumnName="sDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sExtend" msprop:Generator_ColumnVarNameInTable="columnsExtend" msprop:Generator_ColumnPropNameInRow="sExtend" msprop:Generator_ColumnPropNameInTable="sExtendColumn" msprop:Generator_UserColumnName="sExtend">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iVisit" msprop:Generator_ColumnVarNameInTable="columniVisit" msprop:Generator_ColumnPropNameInRow="iVisit" msprop:Generator_ColumnPropNameInTable="iVisitColumn" msprop:Generator_UserColumnName="iVisit" type="xs:int" />
              <xs:element name="iLike" msprop:Generator_ColumnVarNameInTable="columniLike" msprop:Generator_ColumnPropNameInRow="iLike" msprop:Generator_ColumnPropNameInTable="iLikeColumn" msprop:Generator_UserColumnName="iLike" type="xs:int" />
              <xs:element name="iStatus" msprop:Generator_ColumnVarNameInTable="columniStatus" msprop:Generator_ColumnPropNameInRow="iStatus" msprop:Generator_ColumnPropNameInTable="iStatusColumn" msprop:Generator_UserColumnName="iStatus" type="xs:unsignedByte" />
              <xs:element name="tDateTimeCreate" msprop:Generator_ColumnVarNameInTable="columntDateTimeCreate" msprop:Generator_ColumnPropNameInRow="tDateTimeCreate" msprop:Generator_ColumnPropNameInTable="tDateTimeCreateColumn" msprop:Generator_UserColumnName="tDateTimeCreate" type="xs:dateTime" />
              <xs:element name="tDateTimeModify" msprop:Generator_ColumnVarNameInTable="columntDateTimeModify" msprop:Generator_ColumnPropNameInRow="tDateTimeModify" msprop:Generator_ColumnPropNameInTable="tDateTimeModifyColumn" msprop:Generator_UserColumnName="tDateTimeModify" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTopic" />
      <xs:field xpath="mstns:PK_iTopicID" />
    </xs:unique>
  </xs:element>
</xs:schema>